<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<meta http-equiv="X-UA-Compatible" content="IE=9" >
<title>Qualish Group - Software Guides</title>
<link rel="stylesheet" type="text/css" href="../style.css" />
<link rel="shortcut icon" href="../resources/images/qualish.ico" >
</head>
<body bgcolor="#494949">
<center>





<!-- Banner -->
<table cellpadding="0" cellspacing="0" class="banner">
		<td class="qualishbutton" onclick="location.href='../index.html'" onmouseover="this.style.backgroundImage = 'url(../resources/images/qualishbutton-select.png)';" onmouseout="this.style.backgroundImage = 'url(../resources/images/qualishbutton.png)';"></td>
		<td style="width: 10px;"></td>
		<td class="audacitybutton" onclick="location.href='../audacity/index.html'" onmouseover="this.style.backgroundImage = 'url(../resources/images/audacity-select.png)';" onmouseout="this.style.backgroundImage = 'url(../resources/images/audacity.png)';"></td>
		<td class="avastbutton" onclick="location.href='../avast/index.html'" onmouseover="this.style.backgroundImage = 'url(../resources/images/avast-select.png)';" onmouseout="this.style.backgroundImage = 'url(../resources/images/avast.png)';"></td>
		<td class="malwarebytesbutton" onclick="location.href='../malwarebytes/index.html'" onmouseover="this.style.backgroundImage = 'url(../resources/images/malwarebytes-select.png)';" onmouseout="this.style.backgroundImage = 'url(../resources/images/malwarebytes.png)';"></td>
		<td class="firefoxbutton" onclick="location.href='../firefox/index.html'" onmouseover="this.style.backgroundImage = 'url(../resources/images/firefox-select.png)';" onmouseout="this.style.backgroundImage = 'url(../resources/images/firefox.png)';"></td>
		<td class="libreofficebutton" onclick="location.href='index.html'" onmouseover="this.style.backgroundImage = 'url(../resources/images/libreoffice-select.png)';" onmouseout="this.style.backgroundImage = 'url(../resources/images/libreoffice.png)';"></td>
		<td class="photoscapebutton" onclick="location.href='../photoscape/index.html'" onmouseover="this.style.backgroundImage = 'url(../resources/images/photoscape-select.png)';" onmouseout="this.style.backgroundImage = 'url(../resources/images/photoscape.png)';"></td>
		<td style="width: 10px;"></td>
</table>







<!-- Content -->
<table cellpadding="0" cellspacing="0" class="main">
	
	<!-- Navigation Pane -->
	<td id="navpane" class="navpane">

		<h2 style="text-align: center; color: white;">LibreOffice 3</h2>

		<ol>
			<li><a href="index.html">Introduction</a></li>
			<li><a href="gettingstarted.html">Getting Started</a></li>
			<ul>		
				<li><a href="gettingstarted.html#1" class="inactive">Downloading and Installing</a></li>
				<li><a href="gettingstarted.html#2" class="inactive">Creating Your First Document</a></li>
			</ul>
			<li><a href="writer.html">Word Processing with Writer</a></li>
			<ul>
				<li><a href="writer.html#1" class="inactive">Create Headers and Footers</a></li>
				<li><a href="writer.html#2" class="inactive">Insert Page Breaks</a></li>
				<li><a href="writer.html#3" class="inactive">Insert Pictures</a></li>
				<li><a href="writer.html#4" class="inactive">Insert Tables</a></li>
				<li><a href="writer.html#5" class="inactive">Create Comments</a></li>
			</ul>
			<li style="color: #fad478; font-weight: bold;">Spreadsheets with Calc</li>
			<ul>
				<li><a href="#1" class="jump">Insert Rows</a></li>
				<li><a href="#2" class="jump">Insert Columns</a></li>
				<li><a href="#3" class="jump">Perform Simple Calculations</a></li>
				<li><a href="#4" class="jump">Create Charts</a></li>
			</ul>
			<li><a href="impress.html">Presentations with Impress</a></li>
			<ul>
				<li><a href="impress.html#1" class="inactive">Presentation Wizard</a></li>
				<li><a href="impress.html#2" class="inactive">Inserting Slides</a></li>
				<li><a href="impress.html#3" class="inactive">Deleting Slides</a></li>
				<li><a href="impress.html#4" class="inactive">Slide Content</a></li>
				<ul>
					<li><a href="impress.html#5" class="inactive">Select a Layout</a></li>
					<li><a href="impress.html#6" class="inactive">Insert Picture</a></li>
				</ul>
				<li><a href="impress.html#7" class="inactive">Starting a Slide Show</a></li>
			</ul>
			<li><a href="troubleshooting.html">Troubleshooting</a></li>
		</ol>

	</td>

	<td class="space"></td>

	<!-- Content Pane -->
	<td id="content" class="content">

		<center>

		<h2>4: Spreadsheets with Calc</h2>

		<hr class="doubleline"></hr>

		<br>

		<img src="libreoffice-logo.png" border="0"></img>

		<br><br>

		</center>

		Calc is the spreadsheet software included with the LibreOffice suite.  Commonly-used features are covered below.
	
		<a name="1"></a>
		<br><br><font class="sectionheader">Insert Rows</font>
		<br><hr class="doubleline"></hr>
		<div class="note">Note: Rows are created above the selected row or cell.</div>
		
		<ol>
			<li>
				Select a row by clicking on the row number in the far-left column (Figure 4.1).
				<br><br>
				<div id="figure" class="figure"><b>Figure 4.1:</b> Select a row number in the far-left column.<br><img src="4.1.png"></img></div>
			</li>
			<li>Right-click on the row number.</li>
			<li>Click <b>Insert Row</b>.</li>
		</ol>

		<a name="2"></a>
		<br><font class="sectionheader">Insert Columns</font>
		<br><hr class="doubleline"></hr>
		<div class="note">Note: Columns are created to the left of the selected column or cell.</div>
		
		<ol>
			<li>
				Select a column by clicking on the column letter (Figure 4.2).
				<br><br>
				<div id="figure" class="figure"><b>Figure 4.2:</b> Select a column by clicking on the column letter.<br><img src="4.2.png"></img></div>
			</li>
			<li>Right-click on the column letter.</li>
			<li>Click <b>Insert Column</b>.</li>
		</ol>

		<a name="3"></a>
		<br><font class="sectionheader">Perform Simple Calculations</font>
		<br><hr class="doubleline"></hr>

		<ol>
			<li>Create two lists of numbers (Figure 4.3).<br><div class="note">Note: Different values change results in later steps.</div>
				<br>
				<div id="figure" class="figure"><b>Figure 4.3:</b> Enter the numbers shown, keeping the lists side-by-side.<br><img src="4.3.png"></img></div>
			</li>
			<li>Click on cell <b>D2</b> and type <b>=</b> (equal sign).<br><div class="note">Note: After <b>=</b> is entered into the cell, clicking on other cells does not deselect cell D2.</li>
			<li>Click on cell <b>B2</b> to identify it as the first <a href="http://en.wikipedia.org/wiki/Operand" target="new">operand</a>.</li>
			<li>Type in <b style="font-size: 150%;">*</b> (asterisk) to multiply cells.</li>
			<li>Complete the operation by clicking on cell <b>C2</b> (Figure 4.4).
				<br><br>
				<div id="figure" class="figure"><b>Figure 4.4:</b> Selecting cell C2 completes the equation in cell D2.<br><img src="4.4.png"></img></div>
			</li>
			<li>Press <b>Enter</b>.<br><div class="note">Note: The cell now displays the output of the operation.</div></li>
		</ol>

			<div style="padding-left: 20px;">
					<font class="subsectionheader" style="padding-left: 0px;">Repeat the Calculation for Adjacent Rows</font>
					<br>
					To repeat the operation for rows above or below the cell:
					<ol>
						<li>Click on cell <b>D2</b>.</li>
						<li>Click and drag the black box in the bottom-right of the cell until all the cells to the right of the inputs are selected (Figure 4.5).
							<br><br>
							<div id="figure" class="figure"><b>Figure 4.5:</b> Click and drag the black box down until the cells adjacent to the lists are selected.<br><img src="4.5.png"></img></div>	
						</li>
					</ol>
				</div>
		</ol>

		<a name="4"></a>
		<br><br><font class="sectionheader">Create Charts</font>
		<br><hr class="doubleline"></hr>
		<div class="note">Note: This section assumes completion of <a href="#3">"Perform Simple Calculations"</a>.</div>
		
		<ol>
			<li>Select all non-empty cells (Figure 4.6).
				<br><br>
				<div id="figure" class="figure"><b>Figure 4.6:</b> Select all cells that contain values by clicking and dragging.<br><img src="4.6.png"></img></div>
			</li>
			<li>Click <b>Insert</b> in the toolbar at the top (Figure 4.7).
				<br><br>
				<div id="figure" class="figure"><b>Figure 4.7:</b> Click <b>Insert</b> in the toolbar.<br><img src="4.7.png"></img></div>
			</li>
			<li>Click <b>Chart</b>.</li>
			<li>Select the type of chart and chart style you want to use (Figure 4.8).<br>
				<div class="note">Note: As changes are made, a preview chart is inserted into the spreadsheet and updates in real-time.</div>
				<br>
				<div id="figure" class="figure"><b>Figure 4.8</b> Select chart options in the middle and top-right portions of the window.<br><img src="4.8.png" class="big"></img>
			</li>
			<li>Click <b>Finish</b> to create the chart (Figure 4.9).<br><div class="note">Note: Click <b>Next</b> in the Chart Wizard to change advanced settings.</div>
				<br>
				<div id="figure" class="figure"><b>Figure 4.9:</b> Create the chart by clicking <b>Finish</b>.<br><img src="4.9.png" class="big"></img></div>
			</li>

		<center>
		<table cellpadding="0" cellspacing="0" id="arrow" class="arrow">
			<td class="arrow-left"></td>
			<td class="arrow-middle"><a href="impress.html">Presentations with Impress</a></td>
			<td class="arrow-right"></td>
		</table>
		</center>

	</td>

</table>

</table>
</body>
</html>